﻿CREATE TABLE [dbo].[EntityType]
(
	[entity_type_id] INT NOT NULL PRIMARY KEY IDENTITY, 
    [name] VARCHAR(64) NOT NULL, 
    [entity_type_uid] UNIQUEIDENTIFIER NOT NULL, 
    [parent_uid] UNIQUEIDENTIFIER NULL, 
    [entity_name_value] VARCHAR(128) NOT NULL, 
    [source] VARCHAR(2048) NULL, 
    [scope] TINYINT NOT NULL DEFAULT 0
)
